TradeIn

Task 1

Get the Data

changing the dtypes into more natural form, like,

recover the Net capital account values for all countries,

Cleaned Dataset

Exploring dataset

The 20 year data from year 2001 to 2020 has 2926 rows of data.

give an estimate on the Net capital account for countries where the information is missing,

Significant Meaning: The above table shows that, African Eastern and Southern(eg from row 1) has empty value from year 2011 to 2020, so our startegy of imputing missing values will be failed.

In order to, make this correct, we will remove any countries that has more than 6 years of empty value.

Check only those country which have more than 5 years of blank data from year 2011 to 2020

Now, Let's impute the values for these country

Impute value with mean strategy

compute the uncertainty on your estimation when the value is missing

obtain and estimate when possible the Net capital account for the last 10 years in all countries

give an estimate of the Net capital account for all countries for the next 5 years

Forecasting

ARIMA

ARIMA:

Parameters:

- p: the no. of lag observations in the model, known as lag order(AR)
- d: the no. of times that the raw observations are differenced, also known as the degree of differencing (I)
- q: the size of the moving average window, also known as the order of the moving average(MA)

Forecasting for France

For all countries

For All Country

Saving Result of Forecast to visualize in Power BI